﻿CREATE TABLE [dbo].[PerformanceHourly] (
    [PerformanceHourlyRowId]  INT           IDENTITY (1, 1) NOT NULL,
    [RoleRowId]               SMALLINT      NOT NULL,
    [PerformanceCounterRowId] SMALLINT      NOT NULL,
    [InstanceNumber]          SMALLINT      NOT NULL,
    [DateTimeUTC]             SMALLDATETIME NOT NULL,
    [MinValue]                FLOAT (53)    NOT NULL,
    [MaxValue]                FLOAT (53)    NOT NULL,
    [AverageValue]            FLOAT (53)    NOT NULL,
    [StdDev]                  FLOAT (53)    NOT NULL,
    CONSTRAINT [PK_PerformanceHourly] PRIMARY KEY CLUSTERED ([PerformanceHourlyRowId] ASC)
);

